Tabela UserDefinition

Definicja tabeli UserDefinition

Name

UserDefinition

Code

UserDefinition

Comment

 


Lista kolumn tabeli UserDefinition

Name

Code

UserDefinitionID

UserDefinitionID

FirstName

FirstName

LastName

LastName

Email

Email

PhoneNo

PhoneNo

Login

Login

Active

Active

Passwd

Passwd

ExternalID

ExternalID


Kolumna UserDefinitionID tabeli UserDefinition

Definicja kolumny UserDefinitionID tabeli UserDefinition

Name

UserDefinitionID

Code

UserDefinitionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FirstName tabeli UserDefinition

Definicja kolumny FirstName tabeli UserDefinition

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna LastName tabeli UserDefinition

Definicja kolumny LastName tabeli UserDefinition

Name

LastName

Code

LastName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna Email tabeli UserDefinition

Definicja kolumny Email tabeli UserDefinition

Name

Email

Code

Email

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna PhoneNo tabeli UserDefinition

Definicja kolumny PhoneNo tabeli UserDefinition

Name

PhoneNo

Code

PhoneNo

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna Login tabeli UserDefinition

Definicja kolumny Login tabeli UserDefinition

Name

Login

Code

Login

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna Active tabeli UserDefinition

Definicja kolumny Active tabeli UserDefinition

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Passwd tabeli UserDefinition

Definicja kolumny Passwd tabeli UserDefinition

Name

Passwd

Code

Passwd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ExternalID tabeli UserDefinition

Definicja kolumny ExternalID tabeli UserDefinition

Name

ExternalID

Code

ExternalID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli UserDefinition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli UserDefinition

Definicja klucza Identifier_1 tabeli UserDefinition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment